<?php
/*
  $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

 E-Commerce Solutions

  Copyright (c) 2005 www.flash-template-design.com

  Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php
  $info_box_contents = array();
  $info_box_contents[] = array('text' => '<p style="color:#FFFFFF; font-weight:bold; font-family:Tahoma, Helvetica, sans-serif; font-size:14px;"><img src="images/marker_header.gif" width="10" height="6" style="margin:0px 5px 0px 10px;">'.TABLE_HEADING_NEW_PRODUCTS.'</p>');

 //new contentBoxHeading($info_box_contents);
?>

<?php 
  if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
    $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
  } else {
    $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
  }

  $row = 0;
  $col = 0;
  $info_box_contents = array();
  while ($new_products = tep_db_fetch_array($new_products_query)) {
    $new_products['products_name'] = tep_get_products_name($new_products['products_id']);
	$new_products['specials_new_products_price'] = tep_get_products_special_price($new_products['products_id']);
	
	
	// if (tep_not_null($new_products['specials_new_products_price'])) {
    //  $whats_new_price = '<span class="productOldPrice">' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</span><br/>';
   //   $whats_new_price .= '<span class="productSpecialPrice">' . $currencies->display_price($new_products['specials_new_products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</span>';
  //  } else {
      $whats_new_price = $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id']));
 //   }
	
	
	
	$sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$new_products['products_id'].' && language_id='.(int)$languages_id;
	$description_query = tep_db_query($sql);
	$description = mysql_fetch_array($description_query, MYSQL_ASSOC);        
	$description['products_description'] = substr($description['products_description'], 0, 65);
	$desc_len = strlen($description['products_description']);
$description['products_description'][$desc_len-1] = '.';
	$description['products_description'][$desc_len-2] = '.';
	$description['products_description'][$desc_len-3] = '.';
		
	/*if  ( ($col == 1 && $row == 0) || ($col == 1 && $row == 2) || ($col == 1 && $row == 4) ){
	$info_box_contents[$row][$col] = array('align' => 'center',
                                           'params' => 'width="1" height="100%" valign="middle"',
                                           'text' => '<table height="115" width="100%" background="'.DIR_WS_IMAGES .'m_vert.jpg" border="0" cellspacing="0" cellpadding="0" >
  <tr>
    <td><div style="width:1px"></div></td>
  </tr>
</table>');
	}*/
	/*elseif (($col == 0 && $row == 1) || ($col == 2 && $row == 1) || ($col == 0 && $row == 3) || ($col == 2 && $row == 3)) {
	$info_box_contents[$row][$col] = array('align' => 'center',
                                           'params' => 'height="1"',
                                           'text' => '<table width="90%" background="'.DIR_WS_IMAGES .'m_horizontal.jpg" border="0" cellspacing="0" cellpadding="0" >
  <tr>
    <td></td>
  </tr>
</table>');
	}*/
/*elseif (($col == 1 && $row == 1) || ($col == 1 && $row == 3)) {
	$info_box_contents[$row][$col] = array('align' => '',
                                           'params' => '',
                                           'text' => '&nbsp;');
	}
else {*/
if($col == 0)
$str='style="padding-right:3px; padding-bottom:8px;"';
else $str='style="padding-bottom:8px;"';	
    
	$info_box_contents[$row][$col] = array('align' => 'left',
                                           'params' => 'class="main" border="0" width="166" height="145" '.$str.' valign="top" align="left"',
                                           'text' => '<table width=100% bgcolor="#FFFFFF"  cellpadding=0 cellspacing=0 border=0>
										   				<tr>
															<td colspan="2" class="main" valign="top" align="left" style="padding:5px 5px 0px 5px;"><span style="font-weight:bold; color:#BB0202;">'.$new_products['products_name'].'</span><br/><span style="color:#A89969;">'.$description['products_description'].'</span></td>
														</tr>
														<tr>
															<td width="79" height="91" valign="top" style="padding-top:9px; padding-bottom:4px;"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'align="absmiddle"') . '</a></td>	
															<td valign="bottom" style="padding-bottom:9px;"><div style="color:#BB0202; font-size:17px;padding-bottom:4px; ">' . $whats_new_price.'</div></td>
															
														</tr>
														<tr>
														   <td colspan="2" bgcolor="#DDD0A8" style="padding-top:3px;">'. tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')).'
														   	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
															  <tr>    
															  	<td width="50%" style="padding-left:10px;" ><a href="'.tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']).'">'.tep_image_button('details.gif', IMAGE_BUTTON_DETAILS).'</a></td>
															 	<td width="50%" style="padding-left:10px;">'.tep_draw_hidden_field('products_id', $new_products['products_id']) . tep_image_submit('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW).'</td>
  															  </tr>
															</table></form>
														  </td>
														</tr>
													</table>'); 

//}
										   
										   
    $col ++;
    if ($col > 1) {
      $col = 0;
      $row ++;
    }
	
  }
  new contentBox($info_box_contents, 0);

?>

<!-- new_products_eof //-->